FO_CPTReviewCombinedDx

This table contains rules, records, for each CPT code and insurance carrier that will have a supporting diagnosis.

A default rule is required for each CPT code and insurance carrier pair.

The default rule must have the ICD field set as 'ALL' and the Reason field set to a value of 1 or 2. This default rule is required so that the system can assume that the test will fail LMRP checking for all conditions that are not defined in the FO_CPTReviewCombinedDx table.

A maximum of four (4) records may be created for each CPT code. (what/how is this enforced?)

 

Field Type Notes

CPTREvMultiDX_ID

int

ID field, a counter. Unique

Carrier

varchar(50)

Code for the insurance carrier FI to which this CPT ICD pair will be assigned.

Enter a valid insurance carrier code.

(what does FI mean and is it really needed here?)

Region

int

Region user assigned to.

Enter a valid region as defined in the FO_Users table.

ChargeTo

varchar(50)

Informational

(any other info to give or what needs to be entered here?)

CPT

varchar(15)

CPT code.

Enter a valid CPT code.

StartDate

datetime

Date rule put into use.

Enter a valid date in MM/DD/YYYY format.

StopDate

datetime

Date rule removed from use.

Enter a valid date in MM/DD/YYYY format.

DiagnosisCode

varchar(50)

Defines list of ICD codes that are payable.

Multidimensional COMMA delimited list, no leading or trailing commas. (true?)

Enter valid diagnosis, ICD, codes separated by commas.

CreateDate

datetime

System timestamp when record is created.

Informational

EditDate

datetime

System timestamp when record is edited.

Informational

DiagCodingMethod

varchar(50)

*** NEED DEFINITION ***